package net.hn.hnms.biz.safety.monitor.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import net.hn.hnms.biz.safety.monitor.domain.SensorMonitorNowPo;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 测点实时统计信息Mapper
 */
public interface SensorMonitorNowMapper extends BaseMapper<SensorMonitorNowPo> {
    @Select("SELECT * from dwd_aqjk_now_sensormonitor where mine_code=#{mineCode} and sensor_type_name=#{sensorTypeName} and data_time=(SELECT max(data_time) from dwd_aqjk_now_sensormonitor) ORDER BY point_location")
    List<SensorMonitorNowPo> selectTypeList(@Param("mineCode") String mineCode, @Param("sensorTypeName") String sensorTypeName);
}
